Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 166158 |
| Missing cells | 27348 |
| Missing cells (%) | 0.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 68.7 MiB |
| Average record size in memory | 433.7 B |
Variable types
| Categorical | 4 |
|---|---|
| Numeric | 13 |
| Text | 2 |
| DateTime | 1 |
year has constant value "" | Constant |
dep_time is highly overall correlated with sched_dep_time and 3 other fields | High correlation |
sched_dep_time is highly overall correlated with dep_time and 3 other fields | High correlation |
dep_delay is highly overall correlated with arr_delay | High correlation |
arr_time is highly overall correlated with dep_time and 3 other fields | High correlation |
sched_arr_time is highly overall correlated with dep_time and 3 other fields | High correlation |
arr_delay is highly overall correlated with dep_delay | High correlation |
flight is highly overall correlated with carrier | High correlation |
air_time is highly overall correlated with distance | High correlation |
distance is highly overall correlated with air_time | High correlation |
hour is highly overall correlated with dep_time and 3 other fields | High correlation |
carrier is highly overall correlated with flight and 1 other fields | High correlation |
origin is highly overall correlated with carrier | High correlation |
dep_time has 4883 (2.9%) missing values | Missing |
dep_delay has 4883 (2.9%) missing values | Missing |
arr_time has 5101 (3.1%) missing values | Missing |
arr_delay has 5480 (3.3%) missing values | Missing |
air_time has 5480 (3.3%) missing values | Missing |
dep_delay has 7963 (4.8%) zeros | Zeros |
arr_delay has 2599 (1.6%) zeros | Zeros |
minute has 30802 (18.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-11-08 01:23:40.511128 |
|---|---|
| Analysis finished | 2023-11-08 01:24:06.551669 |
| Duration | 26.04 seconds |
| Software version | ydata-profiling vv4.6.1 |
| Download configuration | config.json |
year
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.7 MiB |
| 2013 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 664632 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2013 |
|---|---|
| 2nd row | 2013 |
| 3rd row | 2013 |
| 4th row | 2013 |
| 5th row | 2013 |
Common Values
| Value | Count | Frequency (%) |
| 2013 | 166158 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2013 | 166158 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 166158 | |
| 0 | 166158 | |
| 1 | 166158 | |
| 3 | 166158 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 664632 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 166158 | |
| 0 | 166158 | |
| 1 | 166158 | |
| 3 | 166158 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 664632 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 166158 | |
| 0 | 166158 | |
| 1 | 166158 | |
| 3 | 166158 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 664632 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 166158 | |
| 0 | 166158 | |
| 1 | 166158 | |
| 3 | 166158 |
month
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5518362 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.6997793 |
|---|---|
| Coefficient of variation (CV) | 0.47856353 |
| Kurtosis | -1.2445938 |
| Mean | 3.5518362 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.051966521 |
| Sum | 590166 |
| Variance | 2.8892495 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 3 | 28834 | |
| 5 | 28796 | |
| 4 | 28330 | |
| 6 | 28243 | |
| 1 | 27004 | |
| 2 | 24951 |
| Value | Count | Frequency (%) |
| 1 | 27004 | |
| 2 | 24951 | |
| 3 | 28834 | |
| 4 | 28330 | |
| 5 | 28796 | |
| 6 | 28243 |
| Value | Count | Frequency (%) |
| 6 | 28243 | |
| 5 | 28796 | |
| 4 | 28330 | |
| 3 | 28834 | |
| 2 | 24951 | |
| 1 | 27004 |
day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.642515 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7240706 |
|---|---|
| Coefficient of variation (CV) | 0.55771534 |
| Kurtosis | -1.1847736 |
| Mean | 15.642515 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0085704498 |
| Sum | 2599129 |
| Variance | 76.109407 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 28 | 5757 | 3.5% |
| 21 | 5727 | 3.4% |
| 14 | 5727 | 3.4% |
| 7 | 5686 | 3.4% |
| 24 | 5658 | 3.4% |
| 17 | 5640 | 3.4% |
| 10 | 5623 | 3.4% |
| 3 | 5593 | 3.4% |
| 22 | 5593 | 3.4% |
| 15 | 5590 | 3.4% |
| Other values (21) | 109564 |
| Value | Count | Frequency (%) |
| 1 | 5414 | |
| 2 | 5267 | |
| 3 | 5593 | |
| 4 | 5514 | |
| 5 | 5444 | |
| 6 | 5431 | |
| 7 | 5686 | |
| 8 | 5533 | |
| 9 | 5215 | |
| 10 | 5623 |
| Value | Count | Frequency (%) |
| 31 | 2811 | |
| 30 | 4536 | |
| 29 | 4633 | |
| 28 | 5757 | |
| 27 | 5425 | |
| 26 | 5296 | |
| 25 | 5565 | |
| 24 | 5658 | |
| 23 | 5283 | |
| 22 | 5593 |
dep_time
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 1291 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 4883 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1351.7406 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 623 |
| Q1 | 909 |
| median | 1407 |
| Q3 | 1748 |
| 95-th percentile | 2114 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 839 |
Descriptive statistics
| Standard deviation | 490.41005 |
|---|---|
| Coefficient of variation (CV) | 0.36279895 |
| Kurtosis | -1.0828551 |
| Mean | 1351.7406 |
| Median Absolute Deviation (MAD) | 425 |
| Skewness | -0.039285285 |
| Sum | 2.1800196 × 108 |
| Variance | 240502.02 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 441 | 0.3% |
| 557 | 420 | 0.3% |
| 556 | 416 | 0.3% |
| 655 | 393 | 0.2% |
| 855 | 385 | 0.2% |
| 755 | 376 | 0.2% |
| 1455 | 363 | 0.2% |
| 654 | 361 | 0.2% |
| 856 | 358 | 0.2% |
| 558 | 357 | 0.2% |
| Other values (1281) | 157405 | |
| (Missing) | 4883 | 2.9% |
| Value | Count | Frequency (%) |
| 1 | 14 | |
| 2 | 26 | |
| 3 | 15 | |
| 4 | 15 | |
| 5 | 12 | |
| 6 | 8 | < 0.1% |
| 7 | 12 | |
| 8 | 12 | |
| 9 | 10 | < 0.1% |
| 10 | 12 |
| Value | Count | Frequency (%) |
| 2400 | 11 | < 0.1% |
| 2359 | 29 | |
| 2358 | 38 | |
| 2357 | 36 | |
| 2356 | 43 | |
| 2355 | 54 | |
| 2354 | 40 | |
| 2353 | 38 | |
| 2352 | 32 | |
| 2351 | 28 |
sched_dep_time
Real number (ℝ)
HIGH CORRELATION
| Distinct | 969 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1346.8721 |
| Minimum | 500 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 630 |
| Q1 | 909 |
| median | 1400 |
| Q3 | 1730 |
| 95-th percentile | 2045 |
| Maximum | 2359 |
| Range | 1859 |
| Interquartile range (IQR) | 821 |
Descriptive statistics
| Standard deviation | 468.25773 |
|---|---|
| Coefficient of variation (CV) | 0.3476631 |
| Kurtosis | -1.2029954 |
| Mean | 1346.8721 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | -0.020562276 |
| Sum | 2.2379358 × 108 |
| Variance | 219265.31 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 3702 | 2.2% |
| 900 | 2558 | 1.5% |
| 700 | 2463 | 1.5% |
| 630 | 2407 | 1.4% |
| 1700 | 2407 | 1.4% |
| 1200 | 2388 | 1.4% |
| 1600 | 2216 | 1.3% |
| 2000 | 1848 | 1.1% |
| 1900 | 1768 | 1.1% |
| 1300 | 1739 | 1.0% |
| Other values (959) | 142662 |
| Value | Count | Frequency (%) |
| 500 | 176 | |
| 501 | 1 | < 0.1% |
| 505 | 1 | < 0.1% |
| 510 | 4 | < 0.1% |
| 515 | 113 | |
| 520 | 1 | < 0.1% |
| 525 | 35 | < 0.1% |
| 527 | 1 | < 0.1% |
| 529 | 3 | < 0.1% |
| 530 | 102 |
| Value | Count | Frequency (%) |
| 2359 | 380 | |
| 2358 | 44 | < 0.1% |
| 2355 | 62 | < 0.1% |
| 2352 | 16 | < 0.1% |
| 2345 | 1 | < 0.1% |
| 2339 | 1 | < 0.1% |
| 2315 | 1 | < 0.1% |
| 2300 | 11 | < 0.1% |
| 2258 | 17 | < 0.1% |
| 2255 | 180 |
dep_delay
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 469 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 4883 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.715666 |
| Minimum | -33 |
|---|---|
| Maximum | 1301 |
| Zeros | 7963 |
| Zeros (%) | 4.8% |
| Negative | 88828 |
| Negative (%) | 53.5% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -33 |
|---|---|
| 5-th percentile | -9 |
| Q1 | -5 |
| median | -1 |
| Q3 | 12 |
| 95-th percentile | 93 |
| Maximum | 1301 |
| Range | 1334 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 41.677452 |
|---|---|
| Coefficient of variation (CV) | 3.0386751 |
| Kurtosis | 46.419289 |
| Mean | 13.715666 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 4.7822367 |
| Sum | 2211994 |
| Variance | 1737.01 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 12104 | 7.3% |
| -4 | 12052 | 7.3% |
| -3 | 11785 | 7.1% |
| -2 | 10540 | 6.3% |
| -6 | 9939 | 6.0% |
| -1 | 9150 | 5.5% |
| -7 | 8077 | 4.9% |
| 0 | 7963 | 4.8% |
| -8 | 5639 | 3.4% |
| 1 | 3964 | 2.4% |
| Other values (459) | 70062 | |
| (Missing) | 4883 | 2.9% |
| Value | Count | Frequency (%) |
| -33 | 1 | < 0.1% |
| -30 | 1 | < 0.1% |
| -27 | 1 | < 0.1% |
| -25 | 1 | < 0.1% |
| -24 | 3 | < 0.1% |
| -23 | 1 | < 0.1% |
| -22 | 5 | < 0.1% |
| -21 | 6 | < 0.1% |
| -20 | 21 | |
| -19 | 10 |
| Value | Count | Frequency (%) |
| 1301 | 1 | < 0.1% |
| 1137 | 1 | < 0.1% |
| 1126 | 1 | < 0.1% |
| 960 | 1 | < 0.1% |
| 911 | 1 | < 0.1% |
| 899 | 1 | < 0.1% |
| 878 | 1 | < 0.1% |
| 853 | 3 | |
| 812 | 1 | < 0.1% |
| 803 | 1 | < 0.1% |
arr_time
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 1392 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 5101 |
| Missing (%) | 3.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1503.949 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 732 |
| Q1 | 1106 |
| median | 1538 |
| Q3 | 1945 |
| 95-th percentile | 2249 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 839 |
Descriptive statistics
| Standard deviation | 536.36355 |
|---|---|
| Coefficient of variation (CV) | 0.35663679 |
| Kurtosis | -0.17961664 |
| Mean | 1503.949 |
| Median Absolute Deviation (MAD) | 420 |
| Skewness | -0.48486168 |
| Sum | 2.4222152 × 108 |
| Variance | 287685.86 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1006 | 240 | 0.1% |
| 1008 | 235 | 0.1% |
| 1012 | 231 | 0.1% |
| 1005 | 230 | 0.1% |
| 1013 | 230 | 0.1% |
| 1015 | 228 | 0.1% |
| 2017 | 225 | 0.1% |
| 2029 | 224 | 0.1% |
| 1049 | 222 | 0.1% |
| 1016 | 222 | 0.1% |
| Other values (1382) | 158770 | |
| (Missing) | 5101 | 3.1% |
| Value | Count | Frequency (%) |
| 1 | 94 | |
| 2 | 79 | |
| 3 | 72 | |
| 4 | 93 | |
| 5 | 104 | |
| 6 | 64 | |
| 7 | 93 | |
| 8 | 69 | |
| 9 | 75 | |
| 10 | 92 |
| Value | Count | Frequency (%) |
| 2400 | 79 | |
| 2359 | 120 | |
| 2358 | 88 | |
| 2357 | 102 | |
| 2356 | 93 | |
| 2355 | 95 | |
| 2354 | 110 | |
| 2353 | 83 | |
| 2352 | 94 | |
| 2351 | 85 |
sched_arr_time
Real number (ℝ)
HIGH CORRELATION
| Distinct | 1134 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1539.4886 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 815 |
| Q1 | 1125 |
| median | 1600 |
| Q3 | 1950 |
| 95-th percentile | 2245 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 825 |
Descriptive statistics
| Standard deviation | 498.56213 |
|---|---|
| Coefficient of variation (CV) | 0.32384919 |
| Kurtosis | -0.36727828 |
| Mean | 1539.4886 |
| Median Absolute Deviation (MAD) | 416 |
| Skewness | -0.36956113 |
| Sum | 2.5579835 × 108 |
| Variance | 248564.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1820 | 705 | 0.4% |
| 2015 | 705 | 0.4% |
| 2050 | 703 | 0.4% |
| 1015 | 657 | 0.4% |
| 1110 | 629 | 0.4% |
| 1640 | 597 | 0.4% |
| 1220 | 584 | 0.4% |
| 2240 | 583 | 0.4% |
| 1305 | 578 | 0.3% |
| 1645 | 578 | 0.3% |
| Other values (1124) | 159839 |
| Value | Count | Frequency (%) |
| 1 | 152 | |
| 2 | 83 | |
| 3 | 68 | |
| 4 | 74 | |
| 5 | 78 | |
| 6 | 17 | < 0.1% |
| 7 | 31 | < 0.1% |
| 8 | 55 | < 0.1% |
| 9 | 13 | < 0.1% |
| 10 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 364 | |
| 2358 | 197 | |
| 2357 | 305 | |
| 2356 | 264 | |
| 2355 | 171 | |
| 2354 | 128 | 0.1% |
| 2353 | 121 | 0.1% |
| 2352 | 14 | < 0.1% |
| 2351 | 50 | < 0.1% |
| 2350 | 42 | < 0.1% |
arr_delay
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 526 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 5480 |
| Missing (%) | 3.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.1512902 |
| Minimum | -86 |
|---|---|
| Maximum | 1272 |
| Zeros | 2599 |
| Zeros (%) | 1.6% |
| Negative | 90709 |
| Negative (%) | 54.6% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -86 |
|---|---|
| 5-th percentile | -32 |
| Q1 | -16 |
| median | -4 |
| Q3 | 15 |
| 95-th percentile | 96 |
| Maximum | 1272 |
| Range | 1358 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 46.00005 |
|---|---|
| Coefficient of variation (CV) | 5.6432845 |
| Kurtosis | 31.148268 |
| Mean | 8.1512902 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 3.723021 |
| Sum | 1309733 |
| Variance | 2116.0046 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -12 | 3441 | 2.1% |
| -13 | 3419 | 2.1% |
| -10 | 3348 | 2.0% |
| -11 | 3341 | 2.0% |
| -14 | 3332 | 2.0% |
| -15 | 3307 | 2.0% |
| -8 | 3247 | 2.0% |
| -7 | 3240 | 1.9% |
| -9 | 3231 | 1.9% |
| -17 | 3187 | 1.9% |
| Other values (516) | 127585 | |
| (Missing) | 5480 | 3.3% |
| Value | Count | Frequency (%) |
| -86 | 1 | < 0.1% |
| -79 | 1 | < 0.1% |
| -75 | 2 | < 0.1% |
| -74 | 1 | < 0.1% |
| -73 | 1 | < 0.1% |
| -71 | 3 | < 0.1% |
| -70 | 8 | |
| -69 | 7 | |
| -68 | 9 | |
| -67 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1272 | 1 | |
| 1127 | 1 | |
| 1109 | 1 | |
| 931 | 1 | |
| 915 | 1 | |
| 875 | 1 | |
| 852 | 1 | |
| 851 | 1 | |
| 850 | 1 | |
| 834 | 1 |
carrier
Categorical
HIGH CORRELATION
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.3 MiB |
| UA | |
|---|---|
| B6 | |
| EV | |
| DL | |
| AA | |
| Other values (11) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 332316 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UA |
|---|---|
| 2nd row | UA |
| 3rd row | AA |
| 4th row | B6 |
| 5th row | DL |
Common Values
| Value | Count | Frequency (%) |
| UA | 28936 | |
| B6 | 27017 | |
| EV | 26558 | |
| DL | 23623 | |
| AA | 16380 | |
| MQ | 13244 | |
| US | 10123 | 6.1% |
| 9E | 9069 | 5.5% |
| WN | 5919 | 3.6% |
| VX | 2332 | 1.4% |
| Other values (6) | 2957 | 1.8% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ua | 28936 | |
| b6 | 27017 | |
| ev | 26558 | |
| dl | 23623 | |
| aa | 16380 | |
| mq | 13244 | |
| us | 10123 | 6.1% |
| 9e | 9069 | 5.5% |
| wn | 5919 | 3.6% |
| vx | 2332 | 1.4% |
| Other values (6) | 2957 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 62239 | |
| U | 39059 | |
| E | 35627 | |
| V | 29138 | |
| B | 27017 | |
| 6 | 27017 | |
| L | 25451 | |
| D | 23623 | 7.1% |
| Q | 13244 | 4.0% |
| M | 13244 | 4.0% |
| Other values (9) | 36657 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 295895 | |
| Decimal Number | 36421 | 11.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 62239 | |
| U | 39059 | |
| E | 35627 | |
| V | 29138 | |
| B | 27017 | |
| L | 25451 | |
| D | 23623 | 8.0% |
| Q | 13244 | 4.5% |
| M | 13244 | 4.5% |
| S | 10485 | 3.5% |
| Other values (7) | 16768 | 5.7% |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 27017 | |
| 9 | 9404 | 25.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 295895 | |
| Common | 36421 | 11.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 62239 | |
| U | 39059 | |
| E | 35627 | |
| V | 29138 | |
| B | 27017 | |
| L | 25451 | |
| D | 23623 | 8.0% |
| Q | 13244 | 4.5% |
| M | 13244 | 4.5% |
| S | 10485 | 3.5% |
| Other values (7) | 16768 | 5.7% |
Common
| Value | Count | Frequency (%) |
| 6 | 27017 | |
| 9 | 9404 | 25.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 332316 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 62239 | |
| U | 39059 | |
| E | 35627 | |
| V | 29138 | |
| B | 27017 | |
| 6 | 27017 | |
| L | 25451 | |
| D | 23623 | 7.1% |
| Q | 13244 | 4.0% |
| M | 13244 | 4.0% |
| Other values (9) | 36657 |
flight
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2994 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1970.2587 |
| Minimum | 1 |
|---|---|
| Maximum | 8500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 75 |
| Q1 | 553 |
| median | 1464 |
| Q3 | 3697 |
| 95-th percentile | 4662 |
| Maximum | 8500 |
| Range | 8499 |
| Interquartile range (IQR) | 3144 |
Descriptive statistics
| Standard deviation | 1655.0415 |
|---|---|
| Coefficient of variation (CV) | 0.84001232 |
| Kurtosis | -1.0366403 |
| Mean | 1970.2587 |
| Median Absolute Deviation (MAD) | 1062 |
| Skewness | 0.62160158 |
| Sum | 3.2737424 × 108 |
| Variance | 2739162.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 181 | 515 | 0.3% |
| 695 | 475 | 0.3% |
| 27 | 413 | 0.2% |
| 15 | 411 | 0.2% |
| 21 | 390 | 0.2% |
| 345 | 389 | 0.2% |
| 301 | 382 | 0.2% |
| 1109 | 379 | 0.2% |
| 731 | 371 | 0.2% |
| 269 | 371 | 0.2% |
| Other values (2984) | 162062 |
| Value | Count | Frequency (%) |
| 1 | 274 | |
| 2 | 51 | < 0.1% |
| 3 | 224 | |
| 4 | 275 | |
| 5 | 11 | < 0.1% |
| 6 | 210 | |
| 7 | 182 | |
| 8 | 171 | |
| 9 | 153 | |
| 10 | 61 | < 0.1% |
| Value | Count | Frequency (%) |
| 8500 | 1 | < 0.1% |
| 6180 | 6 | < 0.1% |
| 6177 | 13 | |
| 6171 | 1 | < 0.1% |
| 6165 | 1 | < 0.1% |
| 6138 | 2 | < 0.1% |
| 6055 | 29 | |
| 6054 | 25 | |
| 6012 | 6 | < 0.1% |
| 6002 | 1 | < 0.1% |
tailnum
Text
| Distinct | 3825 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 1521 |
| Missing (%) | 0.9% |
| Memory size | 9.9 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.9950679 |
| Min length | 5 |
Characters and Unicode
| Total characters | 987010 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 178 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | N14228 |
|---|---|
| 2nd row | N24211 |
| 3rd row | N619AA |
| 4th row | N804JB |
| 5th row | N668DN |
| Value | Count | Frequency (%) |
| n725mq | 393 | 0.2% |
| n723mq | 390 | 0.2% |
| n713mq | 382 | 0.2% |
| n722mq | 372 | 0.2% |
| n711mq | 369 | 0.2% |
| n738mq | 228 | 0.1% |
| n351jb | 227 | 0.1% |
| n228jb | 220 | 0.1% |
| n258jb | 218 | 0.1% |
| n542mq | 214 | 0.1% |
| Other values (3815) | 161624 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 177572 | |
| 3 | 73333 | 7.4% |
| 1 | 72712 | 7.4% |
| 5 | 67430 | 6.8% |
| A | 58355 | 5.9% |
| 7 | 57315 | 5.8% |
| 2 | 55710 | 5.6% |
| 9 | 51897 | 5.3% |
| 6 | 51091 | 5.2% |
| 4 | 50146 | 5.1% |
| Other values (24) | 271449 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 554108 | |
| Uppercase Letter | 432902 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 177572 | |
| A | 58355 | 13.5% |
| B | 33354 | 7.7% |
| J | 32651 | 7.5% |
| U | 22310 | 5.2% |
| W | 18055 | 4.2% |
| Q | 14650 | 3.4% |
| M | 13946 | 3.2% |
| D | 11828 | 2.7% |
| S | 6856 | 1.6% |
| Other values (14) | 43325 | 10.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 73333 | |
| 1 | 72712 | |
| 5 | 67430 | |
| 7 | 57315 | |
| 2 | 55710 | |
| 9 | 51897 | |
| 6 | 51091 | |
| 4 | 50146 | |
| 8 | 40518 | |
| 0 | 33956 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 554108 | |
| Latin | 432902 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 177572 | |
| A | 58355 | 13.5% |
| B | 33354 | 7.7% |
| J | 32651 | 7.5% |
| U | 22310 | 5.2% |
| W | 18055 | 4.2% |
| Q | 14650 | 3.4% |
| M | 13946 | 3.2% |
| D | 11828 | 2.7% |
| S | 6856 | 1.6% |
| Other values (14) | 43325 | 10.0% |
Common
| Value | Count | Frequency (%) |
| 3 | 73333 | |
| 1 | 72712 | |
| 5 | 67430 | |
| 7 | 57315 | |
| 2 | 55710 | |
| 9 | 51897 | |
| 6 | 51091 | |
| 4 | 50146 | |
| 8 | 40518 | |
| 0 | 33956 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 987010 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 177572 | |
| 3 | 73333 | 7.4% |
| 1 | 72712 | 7.4% |
| 5 | 67430 | 6.8% |
| A | 58355 | 5.9% |
| 7 | 57315 | 5.8% |
| 2 | 55710 | 5.6% |
| 9 | 51897 | 5.3% |
| 6 | 51091 | 5.2% |
| 4 | 50146 | 5.1% |
| Other values (24) | 271449 |
origin
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
| EWR | |
|---|---|
| JFK | |
| LGA |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 498474 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EWR |
|---|---|
| 2nd row | LGA |
| 3rd row | JFK |
| 4th row | JFK |
| 5th row | LGA |
Common Values
| Value | Count | Frequency (%) |
| EWR | 60718 | |
| JFK | 55366 | |
| LGA | 50074 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ewr | 60718 | |
| jfk | 55366 | |
| lga | 50074 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 60718 | |
| W | 60718 | |
| R | 60718 | |
| J | 55366 | |
| F | 55366 | |
| K | 55366 | |
| L | 50074 | |
| G | 50074 | |
| A | 50074 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 498474 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 60718 | |
| W | 60718 | |
| R | 60718 | |
| J | 55366 | |
| F | 55366 | |
| K | 55366 | |
| L | 50074 | |
| G | 50074 | |
| A | 50074 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 498474 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 60718 | |
| W | 60718 | |
| R | 60718 | |
| J | 55366 | |
| F | 55366 | |
| K | 55366 | |
| L | 50074 | |
| G | 50074 | |
| A | 50074 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 498474 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 60718 | |
| W | 60718 | |
| R | 60718 | |
| J | 55366 | |
| F | 55366 | |
| K | 55366 | |
| L | 50074 | |
| G | 50074 | |
| A | 50074 |
dest
Text
| Distinct | 100 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.5 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 498474 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IAH |
|---|---|
| 2nd row | IAH |
| 3rd row | MIA |
| 4th row | BQN |
| 5th row | ATL |
| Value | Count | Frequency (%) |
| atl | 8538 | 5.1% |
| ord | 8354 | 5.0% |
| bos | 7695 | 4.6% |
| lax | 7632 | 4.6% |
| mco | 7058 | 4.2% |
| clt | 6671 | 4.0% |
| fll | 6404 | 3.9% |
| sfo | 6078 | 3.7% |
| mia | 5816 | 3.5% |
| dca | 5117 | 3.1% |
| Other values (90) | 96795 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 52443 | 10.5% |
| L | 46722 | 9.4% |
| S | 41400 | 8.3% |
| D | 38823 | 7.8% |
| O | 33383 | 6.7% |
| C | 31688 | 6.4% |
| T | 30575 | 6.1% |
| M | 29102 | 5.8% |
| I | 21151 | 4.2% |
| F | 20852 | 4.2% |
| Other values (16) | 152335 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 498474 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 52443 | 10.5% |
| L | 46722 | 9.4% |
| S | 41400 | 8.3% |
| D | 38823 | 7.8% |
| O | 33383 | 6.7% |
| C | 31688 | 6.4% |
| T | 30575 | 6.1% |
| M | 29102 | 5.8% |
| I | 21151 | 4.2% |
| F | 20852 | 4.2% |
| Other values (16) | 152335 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 498474 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 52443 | 10.5% |
| L | 46722 | 9.4% |
| S | 41400 | 8.3% |
| D | 38823 | 7.8% |
| O | 33383 | 6.7% |
| C | 31688 | 6.4% |
| T | 30575 | 6.1% |
| M | 29102 | 5.8% |
| I | 21151 | 4.2% |
| F | 20852 | 4.2% |
| Other values (16) | 152335 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 498474 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 52443 | 10.5% |
| L | 46722 | 9.4% |
| S | 41400 | 8.3% |
| D | 38823 | 7.8% |
| O | 33383 | 6.7% |
| C | 31688 | 6.4% |
| T | 30575 | 6.1% |
| M | 29102 | 5.8% |
| I | 21151 | 4.2% |
| F | 20852 | 4.2% |
| Other values (16) | 152335 |
air_time
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 484 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 5480 |
| Missing (%) | 3.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 150.56438 |
| Minimum | 20 |
|---|---|
| Maximum | 695 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 82 |
| median | 131 |
| Q3 | 191 |
| 95-th percentile | 340 |
| Maximum | 695 |
| Range | 675 |
| Interquartile range (IQR) | 109 |
Descriptive statistics
| Standard deviation | 93.399122 |
|---|---|
| Coefficient of variation (CV) | 0.62032683 |
| Kurtosis | 0.99508681 |
| Mean | 150.56438 |
| Median Absolute Deviation (MAD) | 53 |
| Skewness | 1.0778154 |
| Sum | 24192383 |
| Variance | 8723.396 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 42 | 1272 | 0.8% |
| 43 | 1259 | 0.8% |
| 45 | 1240 | 0.7% |
| 47 | 1233 | 0.7% |
| 41 | 1218 | 0.7% |
| 44 | 1206 | 0.7% |
| 40 | 1183 | 0.7% |
| 39 | 1178 | 0.7% |
| 46 | 1177 | 0.7% |
| 109 | 1172 | 0.7% |
| Other values (474) | 148540 | |
| (Missing) | 5480 | 3.3% |
| Value | Count | Frequency (%) |
| 20 | 2 | < 0.1% |
| 21 | 10 | < 0.1% |
| 22 | 27 | < 0.1% |
| 23 | 50 | < 0.1% |
| 24 | 65 | |
| 25 | 74 | |
| 26 | 96 | |
| 27 | 84 | |
| 28 | 120 | |
| 29 | 141 |
| Value | Count | Frequency (%) |
| 695 | 1 | |
| 691 | 1 | |
| 686 | 2 | |
| 683 | 1 | |
| 679 | 1 | |
| 676 | 1 | |
| 671 | 2 | |
| 667 | 1 | |
| 666 | 1 | |
| 665 | 1 |
distance
Real number (ℝ)
HIGH CORRELATION
| Distinct | 203 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1026.7442 |
| Minimum | 80 |
|---|---|
| Maximum | 4983 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 80 |
|---|---|
| 5-th percentile | 199 |
| Q1 | 502 |
| median | 872 |
| Q3 | 1389 |
| 95-th percentile | 2475 |
| Maximum | 4983 |
| Range | 4903 |
| Interquartile range (IQR) | 887 |
Descriptive statistics
| Standard deviation | 726.05415 |
|---|---|
| Coefficient of variation (CV) | 0.70714221 |
| Kurtosis | 1.4018418 |
| Mean | 1026.7442 |
| Median Absolute Deviation (MAD) | 389 |
| Skewness | 1.1600017 |
| Sum | 1.7060176 × 108 |
| Variance | 527154.63 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2475 | 5554 | 3.3% |
| 762 | 5208 | 3.1% |
| 733 | 4149 | 2.5% |
| 2586 | 3977 | 2.4% |
| 719 | 3061 | 1.8% |
| 187 | 2902 | 1.7% |
| 184 | 2829 | 1.7% |
| 1096 | 2789 | 1.7% |
| 544 | 2763 | 1.7% |
| 944 | 2748 | 1.7% |
| Other values (193) | 130178 |
| Value | Count | Frequency (%) |
| 80 | 49 | < 0.1% |
| 94 | 623 | 0.4% |
| 96 | 205 | 0.1% |
| 116 | 311 | 0.2% |
| 143 | 285 | 0.2% |
| 160 | 257 | 0.2% |
| 169 | 426 | 0.3% |
| 173 | 57 | < 0.1% |
| 184 | 2829 | |
| 185 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 4983 | 181 | 0.1% |
| 4963 | 181 | 0.1% |
| 2586 | 3977 | |
| 2576 | 142 | 0.1% |
| 2569 | 147 | 0.1% |
| 2565 | 2101 | 1.3% |
| 2521 | 137 | 0.1% |
| 2475 | 5554 | |
| 2465 | 518 | 0.3% |
| 2454 | 2422 |
hour
Real number (ℝ)
HIGH CORRELATION
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.208964 |
| Minimum | 5 |
|---|---|
| Maximum | 23 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 14 |
| Q3 | 17 |
| 95-th percentile | 20 |
| Maximum | 23 |
| Range | 18 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 4.6691392 |
|---|---|
| Coefficient of variation (CV) | 0.35348262 |
| Kurtosis | -1.2133094 |
| Mean | 13.208964 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.015305656 |
| Sum | 2194775 |
| Variance | 21.80086 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=19)
| Value | Count | Frequency (%) |
| 6 | 13109 | 7.9% |
| 8 | 13071 | 7.9% |
| 17 | 12210 | 7.3% |
| 15 | 11936 | 7.2% |
| 16 | 11543 | 6.9% |
| 7 | 11029 | 6.6% |
| 19 | 10958 | 6.6% |
| 18 | 10857 | 6.5% |
| 14 | 10420 | 6.3% |
| 9 | 10318 | 6.2% |
| Other values (9) | 50707 |
| Value | Count | Frequency (%) |
| 5 | 938 | 0.6% |
| 6 | 13109 | |
| 7 | 11029 | |
| 8 | 13071 | |
| 9 | 10318 | |
| 10 | 7919 | |
| 11 | 7926 | |
| 12 | 8783 | |
| 13 | 9726 | |
| 14 | 10420 |
| Value | Count | Frequency (%) |
| 23 | 516 | 0.3% |
| 22 | 1299 | 0.8% |
| 21 | 5336 | |
| 20 | 8264 | |
| 19 | 10958 | |
| 18 | 10857 | |
| 17 | 12210 | |
| 16 | 11543 | |
| 15 | 11936 | |
| 14 | 10420 |
minute
Real number (ℝ)
ZEROS
| Distinct | 60 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.975752 |
| Minimum | 0 |
|---|---|
| Maximum | 59 |
| Zeros | 30802 |
| Zeros (%) | 18.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7 |
| median | 29 |
| Q3 | 44 |
| 95-th percentile | 57 |
| Maximum | 59 |
| Range | 59 |
| Interquartile range (IQR) | 37 |
Descriptive statistics
| Standard deviation | 19.279158 |
|---|---|
| Coefficient of variation (CV) | 0.74219827 |
| Kurtosis | -1.2421519 |
| Mean | 25.975752 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 0.099749287 |
| Sum | 4316079 |
| Variance | 371.68594 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 30802 | |
| 30 | 15979 | 9.6% |
| 45 | 10734 | 6.5% |
| 15 | 9559 | 5.8% |
| 55 | 9295 | 5.6% |
| 10 | 7651 | 4.6% |
| 59 | 7271 | 4.4% |
| 40 | 7262 | 4.4% |
| 35 | 7179 | 4.3% |
| 5 | 6875 | 4.1% |
| Other values (50) | 53551 |
| Value | Count | Frequency (%) |
| 0 | 30802 | |
| 1 | 927 | 0.6% |
| 2 | 419 | 0.3% |
| 3 | 771 | 0.5% |
| 4 | 626 | 0.4% |
| 5 | 6875 | 4.1% |
| 6 | 683 | 0.4% |
| 7 | 483 | 0.3% |
| 8 | 896 | 0.5% |
| 9 | 792 | 0.5% |
| Value | Count | Frequency (%) |
| 59 | 7271 | |
| 58 | 700 | 0.4% |
| 57 | 793 | 0.5% |
| 56 | 770 | 0.5% |
| 55 | 9295 | |
| 54 | 554 | 0.3% |
| 53 | 599 | 0.4% |
| 52 | 541 | 0.3% |
| 51 | 539 | 0.3% |
| 50 | 6351 |
time_hour
Date
| Distinct | 3439 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Minimum | 2013-01-01 05:00:00 |
|---|---|
| Maximum | 2013-06-30 23:00:00 |
Histogram with fixed size bins (bins=50)
lateflight
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.2 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 166158 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 98788 | |
| 1 | 67370 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 98788 | |
| 1 | 67370 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 98788 | |
| 1 | 67370 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 166158 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 98788 | |
| 1 | 67370 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 166158 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 98788 | |
| 1 | 67370 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 166158 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 98788 | |
| 1 | 67370 |
| month | day | dep_time | sched_dep_time | dep_delay | arr_time | sched_arr_time | arr_delay | flight | air_time | distance | hour | minute | carrier | origin | lateflight | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| month | 1.000 | 0.006 | 0.002 | 0.003 | 0.062 | -0.026 | -0.013 | 0.008 | -0.001 | -0.033 | 0.019 | 0.001 | 0.035 | 0.015 | 0.008 | 0.066 |
| day | 0.006 | 1.000 | 0.001 | 0.002 | 0.037 | -0.010 | -0.001 | 0.036 | 0.004 | -0.004 | -0.001 | 0.001 | 0.003 | 0.000 | 0.000 | 0.104 |
| dep_time | 0.002 | 0.001 | 1.000 | 0.969 | 0.293 | 0.796 | 0.872 | 0.212 | 0.032 | -0.038 | -0.036 | 0.967 | 0.096 | 0.109 | 0.112 | 0.222 |
| sched_dep_time | 0.003 | 0.002 | 0.969 | 1.000 | 0.234 | 0.777 | 0.878 | 0.162 | 0.028 | -0.036 | -0.041 | 0.998 | 0.100 | 0.138 | 0.143 | 0.144 |
| dep_delay | 0.062 | 0.037 | 0.293 | 0.234 | 1.000 | 0.190 | 0.218 | 0.636 | -0.015 | 0.053 | 0.052 | 0.231 | 0.068 | 0.039 | 0.022 | 0.249 |
| arr_time | -0.026 | -0.010 | 0.796 | 0.777 | 0.190 | 1.000 | 0.866 | 0.123 | 0.017 | 0.055 | 0.050 | 0.775 | 0.058 | 0.107 | 0.115 | 0.246 |
| sched_arr_time | -0.013 | -0.001 | 0.872 | 0.878 | 0.218 | 0.866 | 1.000 | 0.127 | 0.006 | 0.075 | 0.069 | 0.876 | 0.064 | 0.137 | 0.140 | 0.140 |
| arr_delay | 0.008 | 0.036 | 0.212 | 0.162 | 0.636 | 0.123 | 0.127 | 1.000 | 0.087 | -0.052 | -0.099 | 0.161 | 0.027 | 0.048 | 0.033 | 0.419 |
| flight | -0.001 | 0.004 | 0.032 | 0.028 | -0.015 | 0.017 | 0.006 | 0.087 | 1.000 | -0.468 | -0.473 | 0.028 | -0.013 | 0.504 | 0.320 | 0.079 |
| air_time | -0.033 | -0.004 | -0.038 | -0.036 | 0.053 | 0.055 | 0.075 | -0.052 | -0.468 | 1.000 | 0.985 | -0.040 | 0.042 | 0.387 | 0.244 | 0.094 |
| distance | 0.019 | -0.001 | -0.036 | -0.041 | 0.052 | 0.050 | 0.069 | -0.099 | -0.473 | 0.985 | 1.000 | -0.044 | 0.044 | 0.437 | 0.254 | 0.053 |
| hour | 0.001 | 0.001 | 0.967 | 0.998 | 0.231 | 0.775 | 0.876 | 0.161 | 0.028 | -0.040 | -0.044 | 1.000 | 0.039 | 0.133 | 0.133 | 0.144 |
| minute | 0.035 | 0.003 | 0.096 | 0.100 | 0.068 | 0.058 | 0.064 | 0.027 | -0.013 | 0.042 | 0.044 | 0.039 | 1.000 | 0.109 | 0.125 | 0.040 |
| carrier | 0.015 | 0.000 | 0.109 | 0.138 | 0.039 | 0.107 | 0.137 | 0.048 | 0.504 | 0.387 | 0.437 | 0.133 | 0.109 | 1.000 | 0.613 | 0.120 |
| origin | 0.008 | 0.000 | 0.112 | 0.143 | 0.022 | 0.115 | 0.140 | 0.033 | 0.320 | 0.244 | 0.254 | 0.133 | 0.125 | 0.613 | 1.000 | 0.050 |
| lateflight | 0.066 | 0.104 | 0.222 | 0.144 | 0.249 | 0.246 | 0.140 | 0.419 | 0.079 | 0.094 | 0.053 | 0.144 | 0.040 | 0.120 | 0.050 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| year | month | day | dep_time | sched_dep_time | dep_delay | arr_time | sched_arr_time | arr_delay | carrier | flight | tailnum | origin | dest | air_time | distance | hour | minute | time_hour | lateflight | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2013 | 1 | 1 | 517.0 | 515 | 2.0 | 830.0 | 819 | 11.0 | UA | 1545 | N14228 | EWR | IAH | 227.0 | 1400 | 5 | 15 | 2013-01-01 05:00:00 | 1 |
| 1 | 2013 | 1 | 1 | 533.0 | 529 | 4.0 | 850.0 | 830 | 20.0 | UA | 1714 | N24211 | LGA | IAH | 227.0 | 1416 | 5 | 29 | 2013-01-01 05:00:00 | 1 |
| 2 | 2013 | 1 | 1 | 542.0 | 540 | 2.0 | 923.0 | 850 | 33.0 | AA | 1141 | N619AA | JFK | MIA | 160.0 | 1089 | 5 | 40 | 2013-01-01 05:00:00 | 1 |
| 3 | 2013 | 1 | 1 | 544.0 | 545 | -1.0 | 1004.0 | 1022 | -18.0 | B6 | 725 | N804JB | JFK | BQN | 183.0 | 1576 | 5 | 45 | 2013-01-01 05:00:00 | 0 |
| 4 | 2013 | 1 | 1 | 554.0 | 600 | -6.0 | 812.0 | 837 | -25.0 | DL | 461 | N668DN | LGA | ATL | 116.0 | 762 | 6 | 0 | 2013-01-01 06:00:00 | 0 |
| 5 | 2013 | 1 | 1 | 554.0 | 558 | -4.0 | 740.0 | 728 | 12.0 | UA | 1696 | N39463 | EWR | ORD | 150.0 | 719 | 5 | 58 | 2013-01-01 05:00:00 | 1 |
| 6 | 2013 | 1 | 1 | 555.0 | 600 | -5.0 | 913.0 | 854 | 19.0 | B6 | 507 | N516JB | EWR | FLL | 158.0 | 1065 | 6 | 0 | 2013-01-01 06:00:00 | 1 |
| 7 | 2013 | 1 | 1 | 557.0 | 600 | -3.0 | 709.0 | 723 | -14.0 | EV | 5708 | N829AS | LGA | IAD | 53.0 | 229 | 6 | 0 | 2013-01-01 06:00:00 | 0 |
| 8 | 2013 | 1 | 1 | 557.0 | 600 | -3.0 | 838.0 | 846 | -8.0 | B6 | 79 | N593JB | JFK | MCO | 140.0 | 944 | 6 | 0 | 2013-01-01 06:00:00 | 0 |
| 9 | 2013 | 1 | 1 | 558.0 | 600 | -2.0 | 753.0 | 745 | 8.0 | AA | 301 | N3ALAA | LGA | ORD | 138.0 | 733 | 6 | 0 | 2013-01-01 06:00:00 | 1 |
| year | month | day | dep_time | sched_dep_time | dep_delay | arr_time | sched_arr_time | arr_delay | carrier | flight | tailnum | origin | dest | air_time | distance | hour | minute | time_hour | lateflight | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166148 | 2013 | 6 | 30 | NaN | 1500 | NaN | NaN | 1724 | NaN | EV | 5599 | N716EV | LGA | CHS | NaN | 641 | 15 | 0 | 2013-06-30 15:00:00 | 0 |
| 166149 | 2013 | 6 | 30 | NaN | 1457 | NaN | NaN | 1653 | NaN | EV | 5814 | N12921 | EWR | CLT | NaN | 529 | 14 | 57 | 2013-06-30 14:00:00 | 0 |
| 166150 | 2013 | 6 | 30 | NaN | 1635 | NaN | NaN | 1827 | NaN | EV | 5817 | N21129 | EWR | MEM | NaN | 946 | 16 | 35 | 2013-06-30 16:00:00 | 0 |
| 166151 | 2013 | 6 | 30 | NaN | 1405 | NaN | NaN | 1524 | NaN | EV | 5712 | N877AS | JFK | IAD | NaN | 228 | 14 | 5 | 2013-06-30 14:00:00 | 0 |
| 166152 | 2013 | 6 | 30 | NaN | 1442 | NaN | NaN | 1608 | NaN | EV | 5713 | N836AS | LGA | IAD | NaN | 229 | 14 | 42 | 2013-06-30 14:00:00 | 0 |
| 166153 | 2013 | 6 | 30 | NaN | 1945 | NaN | NaN | 2104 | NaN | EV | 5714 | N836AS | JFK | IAD | NaN | 228 | 19 | 45 | 2013-06-30 19:00:00 | 0 |
| 166154 | 2013 | 6 | 30 | NaN | 1610 | NaN | NaN | 1805 | NaN | EV | 4092 | N16147 | EWR | DAY | NaN | 533 | 16 | 10 | 2013-06-30 16:00:00 | 0 |
| 166155 | 2013 | 6 | 30 | NaN | 1709 | NaN | NaN | 1856 | NaN | EV | 4662 | N16911 | EWR | RDU | NaN | 416 | 17 | 9 | 2013-06-30 17:00:00 | 0 |
| 166156 | 2013 | 6 | 30 | NaN | 2059 | NaN | NaN | 2307 | NaN | EV | 5254 | N760EV | LGA | DSM | NaN | 1031 | 20 | 59 | 2013-06-30 20:00:00 | 0 |
| 166157 | 2013 | 6 | 30 | NaN | 1915 | NaN | NaN | 2131 | NaN | EV | 5268 | N744EV | LGA | CLT | NaN | 544 | 19 | 15 | 2013-06-30 19:00:00 | 0 |